USE [TIMEKEEPER]
GO
/****** Object:  StoredProcedure [dbo].[insertTerminalSetting]    Script Date: 01/23/2013 10:48:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[updateTerminalSetting] 
	@machineNo numeric(2, 0),
	@useType numeric(1, 0),
	@device numeric(1, 0),
	@ipAddress nvarchar(15),
	@netPortNo numeric(4, 0),
	@groupID numeric(2, 0),
	@updateDateTime datetime
AS
UPDATE [TIMEKEEPER].[dbo].[TERMINAL_SETTING]
   SET [GROUP_ID] = @groupID
      ,[USE_TYPE] = @useType
      ,[DEVICE] = @device
      ,[IP_ADRESS] = @ipAddress
      ,[NETPORT_NO] = @netPortNo
      ,[UPDATE_DATE_TIME] = @updateDateTime
 WHERE [MACHINE_NO] = @machineNo
GO